is right join ever required